FaApproveDisbCriteriaSubsequent

Logical Entity Name | FaApproveDisbCriteriaSubsequent
Default Table Name | FaApproveDisbCriteriaSubsequent
Physical Only | NO
Owner | dbo
Definition |
Note |

FaApproveDisbCriteriaSubsequent Columns

ColumnName | Domain | Datatype | NULL | Definition
FaApproveDisbCriteriaSubsequentID |  | int | NO |
FaApproveDisbCriteriaID |  | int | NO |
Code |  | char(10) | NO |
Descrip |  | varchar(40) | NO |
MinPctAttFlag |  | bit | NO |
MinPctAtt |  | numeric(8, 2) | NO |
MinHoursAttFlag |  | bit | NO |
MinHoursAtt |  | numeric(9, 2) | NO |
MinNumAvgFlag |  | bit | NO |
MinNumAvg |  | numeric(11, 6) | NO |
MinCumulativeGPAFlag |  | bit | NO |
MinCumulativeGPA |  | numeric(18, 6) | NO |
MinHoursCreditsSchedFlag |  | bit | NO |
MinHoursSched |  | numeric(18, 2) | NO |
MinCreditsSched |  | numeric(18, 2) | NO |
MinHoursCreditsCompFlag |  | bit | NO |
MinHoursComp |  | numeric(18, 2) | NO |
MinCreditsComp |  | numeric(18, 2) | NO |
FACrAttemptEarnedFlag |  | bit | NO |
FACrEarnedAttemp |  | char(1) | NO |
MaxDaysAfterStudLDAFlag |  | bit | NO |
MaxDaysAfterStudLDA |  | int | NO |
MissingDocsFlag |  | bit | NO |
StudSchoolStatusFlag |  | bit | NO |
ReqStudSAPFlag |  | bit | NO |
ReqStudSAP |  | char(8) | NO |
ISIROnFileFlag |  | bit | NO |
AcceptedOriginationFlag |  | bit | NO |
VerifyStatusFlag |  | bit | NO |
VerifyStatus |  | varchar(25) | NO |
MaxDiffDisbAmtFlag |  | bit | NO |
MaxDiffDisbAmt |  | money | NO |
MaxDaysTermDisbDateFlag |  | bit | NO |
MaxDaysTermDisbDate |  | int | NO |
FirstTimeTermStudFlag |  | bit | NO |
MaxDaysFromLoanEndDateFlag |  | bit | NO |
MaxDaysFromLoanEndDate |  | int | NO |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
Ts |  | timestamp | NO |
MatchEnrollmentPackagedStatusFlag |  | bit | NO |
EvaluateTerm |  | bit | NO |
CheckAttendanceAll |  | bit | NO |
CheckCompletionDate |  | bit | NO |
CertifiedBeforeLDA |  | bit | NO |
StateofResidencyFlag |  | bit | NO |
StateofResidencyState |  | char(2) | YES |
StateResidentSinceFlag |  | bit | NO |
ResidentYears |  | smallint | YES |
BachelorsDegree |  | char(1) | NO |
GraduateLevelProgram |  | char(1) | NO |
EntranceInterview |  | bit | NO |
MinAdAttStatId |  | int | YES |
MinPaymentPeriodAttFlag |  | bit | NO |
MinPaymentPeriodAtt |  | numeric(9, 2) | NO |
EnrollmentIntensityFlag |  | bit | NO |
FaCreditsNonT4Awards |  | bit | NO |

FaApproveDisbCriteriaSubsequent Primary and Unique Keys

Key Name | Key Type | Keys
FaApproveDisbCriteriaSubsequentID | PrimaryKey | FaApproveDisbCriteriaSubsequentID

FaApproveDisbCriteriaSubsequent Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaApproveDisbCriteria | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteriaSubsequent_FaApproveDisbCriteriaID_FaApproveDisbCriteria_aFaApproveDisbCriteriaID |  |  | FaApproveDisbCriteriaID | NO | YES
AdAttStat | Non-Identifying | Zero or One to Zero or More | FK_FaApproveDisbCriteriaSubsequent_MinAdAttStatId_AdAttStat_AdAttStatId |  |  | MinAdAttStatId | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteriaSubsequent_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaApproveDisbCriteriaSubsequent Check Constraints

Check Constraint Name | CheckConstraint
Chk_[FaApproveDisbCriteriaSubsequent_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched |
Chk_[FaApproveDisbCriteriaSubsequent_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp |
Chk_FaApproveDisbCriteriaSubsequent_MinPctAttFlag_MinPctAtt | ([MinPctAttFlag]=(1) AND [MinPctAtt]>(0) OR [MinPctAttFlag]=(0) AND [MinPctAtt]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MinNumAvgFlag_MinNumAvg | ([MinNumAvgFlag]=(1) AND [MinNumAvg]>(0) OR [MinNumAvgFlag]=(0) AND [MinNumAvg]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MinHoursAttFlag_MinHoursAtt | ([MinHoursAttFlag]=(1) AND [MinHoursAtt]>(0) OR [MinHoursAttFlag]=(0) AND [MinHoursAtt]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MinCumulativeGPAFlag_MinCumulativeGPA | ([MinCumulativeGPAFlag]=(1) AND [MinCumulativeGPA]>(0) OR [MinCumulativeGPAFlag]=(0) AND [MinCumulativeGPA]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MaxDiffDisbAmtFlag_MaxDiffDisbAmt | ([MaxDiffDisbAmtFlag]=(1) AND [MaxDiffDisbAmt]>=(0) OR [MaxDiffDisbAmtFlag]=(0) AND [MaxDiffDisbAmt]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate | ([MaxDaysFromLoanEndDateFlag]=(1) AND [MaxDaysFromLoanEndDate]>=(0) OR [MaxDaysFromLoanEndDateFlag]=(0) AND [MaxDaysFromLoanEndDate]=(0))
Chk_FaApproveDisbCriteriaSubsequent_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA | ([MaxDaysAfterStudLDAFlag]=(1) AND [MaxDaysAfterStudLDA]>=(0) OR [MaxDaysAfterStudLDAFlag]=(0) AND [MaxDaysAfterStudLDAFlag]=(0))

FaApproveDisbCriteriaSubsequent Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaApproveDisbCriteriaSubsequent Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DisbursementApprovalRuleMultipleDisbursement | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaApproveDisbCriteriaSubsequent | NO |  |  |

FaApproveDisbCriteriaSubsequent Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaApproveDisbCriteriaSubsequent Data Movement Rules

Name | Type | Rule Text/Value